package com.be.beadmin.device.entity;


import cn.hutool.core.date.DateTime;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.be.beadmin.common.entity.BaseEntity;
import lombok.Getter;
import lombok.Setter;
import java.util.Date;

import javax.persistence.*;



/**
* @website
* @description /
* @author zty
* @date 2023-07-30
**/
@Entity
@Getter
@Setter
@Table(name="t_de_spare_info")
public class SpareInfo extends BaseEntity {

    @Column(name = "warehouse_name",columnDefinition = "VARCHAR(200) COMMENT '仓库名称'")
    private String warehouseName;

    @Column(name = "warehouse_id",columnDefinition = "VARCHAR(20) COMMENT '仓库编码'")
    private String warehouseId;

    @Column(name = "spare_name",columnDefinition = "VARCHAR(200) COMMENT '备件名称'")
    private String spareName;

    @Column(name = "spare_id",columnDefinition = "VARCHAR(20) COMMENT '备件编码'")
    private String spareId;

    @Column(name = "spare_type",columnDefinition = "VARCHAR(20) COMMENT '规格型号'")
    private String spareType;

    @Column(name = "manufacturer",columnDefinition = "VARCHAR(20) COMMENT '品牌'")
    private String manufacturer;

    @Column(name = "vendor",columnDefinition = "VARCHAR(20) COMMENT '供应商'")
    private String vendor;

    @Column(name = "QTY",columnDefinition = "float COMMENT '库存数量'")
    private float QTY;

    @Column(name = "identification",columnDefinition = "VARCHAR(50) COMMENT '唯一标识'  not null")
    private String identification;

    @Column(name = "unit",columnDefinition = "VARCHAR(20) COMMENT '单位'")
    private String unit;

    @Column(name = "availableQTY",columnDefinition = "float COMMENT '可用库存'")
    private float availableQTY;

    @Column(name = "safeQTY",columnDefinition = "float COMMENT '安全库存'")
    private float safeQTY;

    @Column(name = "contact",columnDefinition = "VARCHAR(20) COMMENT '联系人'")
    private String contact;

    @Column(name = "telephone",columnDefinition = "VARCHAR(20) COMMENT '联系方式'")
    private String telephone;

    @Column(name = "contract_id",columnDefinition = "VARCHAR(20) COMMENT '采购编号'")
    private String contractId;


    @Column(name = "contract_date",columnDefinition = "datetime COMMENT '采购日期'")
    private Date contractDate;

    @Column(name = "location_code",columnDefinition = "VARCHAR(20) COMMENT '库位编码'")
    private String locationCode;

}
